UCSF

Parameters Provided:

name.synonym = 1-Hydroxy-4-n-butylbenzene; 4-Butylphenol; 4-n-Butylphenol; AI3-22444; BRN 2042120; EINECS 216-672-5; LS-104123; NSC 407848; Phenol, 4-butyl-; Phenol, p-butyl; p-Butylphenol; p-Hydroxybutylbenzene
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-Hydroxy-4-n-butylbenzene; 4-Butylphenol; 4-n-Butylphenol; AI3-22444; BRN 2042120; EINECS 216-672-5; LS-104123; NSC 407848; Phenol, 4-butyl-; Phenol, p-butyl; p-Butylphenol; p-Hydroxybutylbenzene' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-Hydroxy-4-n-butylbenzene%3B+4-Butylphenol%3B+4-n-Butylphenol%3B+AI3-22444%3B+BRN+2042120%3B+EINECS+216-672-5%3B+LS-104123%3B+NSC+407848%3B+Phenol%2C+4-butyl-%3B+Phenol%2C+p-butyl%3B+p-Butylphenol%3B+p-Hydroxybutylbenzene&filter.purchasability=all

Embed Link to Results